# -*- coding: utf-8 -*-
# @Time    : 2024/8/31 13:51
# @Author  : qd
# @Email   : 1518603573@qq.com
# @File    : utils.py
# @Software: PyCharm
import xlrd
def read_excel_by_xlrd(excel): # 以列表形式从excel表格中取出来
    wb=xlrd.open_workbook(excel)
    sheet=wb.sheet_by_name("Sheet1")
    datas=[]
    for line in range(1,sheet.nrows):
        datas.append(sheet.row_values(line))
    return datas
if __name__ == '__main__':
    a=read_excel_by_xlrd(r"D:\crm-web-group-b\datas\files\fiance_ysk_add.xlsx")
    print(a)